group/views.py

@@ -13,6 +13,7 @@ from message.models import UserMessageInfo

                 
              

                 from group.serializers import GroupInfoSerializer, GroupUserInfoSerializer, GroupPhotoInfoSerializer
              

                 
              

                +from utils.page_utils import pagination
              

                 from utils.thumbnail_utils import make_thumb
              

                 
              

                 from utils.error.errno_utils import UserStatusCode, GroupStatusCode, GroupPhotoStatusCode
              
@@ -642,11 +643,19 @@ def thumbup_cancel_api(request):

                 
              

                 def pai2_home_api(request):
              

                     user_id = request.POST.get('user_id', '')
              

                +    page = int(request.POST.get('page', 1))
              

                +    num = int(request.POST.get('num', settings.PAI2_HOME_PER_PAGE))
              

                 
              

                     cursor = connection.cursor()
              

                -    cursor.execute(r"select T1.group_id, T2.group_name, T2.group_avatar, T3.photo_thumbnail_path, T3.comment_num, T3.thumbup_num, T3.created_at from (select * from group_groupuserinfo where user_id='%s') as T1 left outer join group_groupinfo as T2 on T1.group_id = T2.group_id left outer join group_groupphotoinfo as T3 on T1.group_id = T3.group_id and T3.id > T1.current_id order by thumbup_num desc;" % user_id)
              

                +    cursor.execute(r"select T1.group_id, T2.group_name, T2.group_avatar, T3.photo_thumbnail_path, T3.comment_num, T3.thumbup_num, T3.created_at from (select * from group_groupuserinfo where user_id='{user_id}') as T1 left outer join group_groupinfo as T2 on T1.group_id = T2.group_id left outer join group_groupphotoinfo as T3 on T1.group_id = T3.group_id and T3.id > T1.current_id order by T3.id desc, T3.thumbup_num desc limit {offset}, {rows};".format(
              

                +        user_id=user_id,
              

                +        offset=0,
              

                +        rows=settings.PAI2_HOME_MAX_ROWS,
              

                +    ))
              

                     rows = cursor.fetchall()
              

                 
              

                +    rows, left = pagination(rows, page, num)
              

                +
              

                     rows = [{
              

                         'group_id': row[0],
              

                         'group_name': row[1],
              
@@ -661,7 +670,8 @@ def pai2_home_api(request):

                         'status': 200,
              

                         'message': u'获取首页列表成功',
              

                         'data': {
              

                -            'photos': rows
              

                +            'photos': rows,
              

                +            'left': left,
              

                         }
              

                     })
              

                 
              

pai2/settings.py

@@ -203,6 +203,11 @@ WATERMARK_LOGO = os.path.join(PROJ_DIR, 'static/pai2/img/paiai_96_96.png').repla

                 # 缩略图设置
              

                 THUMBNAIL_MAX_WIDTH = 360
              

                 
              

                +# 分页设置
              

                +PAI2_HOME_PER_PAGE = 20
              

                +PAI2_HOME_MAX_PAGE = 20
              

                +PAI2_HOME_MAX_ROWS = 400  # PAI2_HOME_PER_PAGE * PAI2_HOME_MAX_PAGE = 20 * 20 = 400
              

                +
              

                 # 域名设置
              

                 DOMAIN = 'http://pai.ai'
              

                 IMG_DOMAIN = 'http://img.pai.ai'